SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}Cancelada{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}Cancelada{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}Spain{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}Spain{97b03e1956bed597e6d9a8783a77b189de07fdbeee08398fb612735898cea2b5}' OR prCountry = 'Spain')